package ruixinyi.experiment2.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import ruixinyi.experiment2.entity.Course;
import ruixinyi.experiment2.entity.Grade;

import java.util.List;

@Repository

public interface GradeRepository extends JpaRepository<Grade, Integer> {
    List<Grade> findByStudentId(Integer studentId);
    List<Grade> findByCourseId(Integer courseId);
    List<Grade> findByScoreBetween(Double minScore, Double maxScore);
}